BHARAT SEVAK SAMAJ
Time: 2hrs. Max. Marks: 100
I. Fill in the blanks: (10 x 1= 10)
1. ---------- is a data type in MS Access.
2. Formula in MS Excel begin with -------- sign
3. You can customize the range of Sheets to be displayed in startup as 1 to -----.
4. In Access--------- formats the printed information
5. --------- is a complete collection of data displayed in rows & columns.
6. -------- is a program that helps to create slide presentations quickly
7. Delete slide option is in ----------- menu
8. Clip art is a collection of ----------- files
9. Picture option is in ---------- menu
10. In MS Word merge cell is in --------- menu
II. State whether True or False: (10 x 1 = 10)
1. Maximum number of rows in MS Excel is 65536
2. The total number of columns in Excel is 257
3. Header and Footer is in view menu
4. Word count is in Windows menu
5. The Undo command in the Edit menu issued to reverse actions
6. Change case option is in the format menu
7. MS Power Point is a Spread sheet program
8. We cannot find and replace a particular word from MS Excel
9. Word documents cannot be saved on floppies
10. It is possible to protect an Excel sheet using password
III. Write short notes on any SIX: (6 x 10 = 60)
1. Write steps for saving a query.
2. What are the uses of 'Forms' in MS Access?
3. Write steps for create a table using Design view.
4. Write the Steps for creating a form wizard.
5. What is Reports? What the steps are for create a report using an Auto report?
6. Write steps for printing a query.
7. Define Validation
IV. Answer any ONE of the following: (1 x 20 = 20)
1. Explain some functions in Excel.
2. What is a chart and explain different steps for inserting a chart in Excel?